﻿CREATE TABLE [flcr].[PROJECT_RESOURCE_XREF] (
    [PROJ_RESOURCE_XREF_ID] INT           IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]            VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]            DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]         INT           NOT NULL,
    [AUDIT_MOD_USER]        VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]        DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]     INT           NOT NULL,
    [ACTIVE_FLG]            BIT           NOT NULL,
    [PROJ_PLAN_ID]          INT           NOT NULL,
    [RESOURCE_ID]           INT           NOT NULL,
    [BOOKING_TYPE]          INT           NOT NULL,
    [RESOURCE_WORK]         VARCHAR (50)  NOT NULL,
    [RESOURCE_UNITS]        VARCHAR (50)  NOT NULL
);

